# -*- codeing = utf-8 -*-
import numpy as np
import pandas as pd
import csv
import os

df = pd.read_csv('./vip.csv')#读取指定路径的文件
df['vip月票'] = df['vip月票'].str.replace('月票','').astype(np.int32)
df['排名'] = df['排名'].str.replace('NO.','')
#print(df)
df1 = pd.read_csv('./月票.csv')
df1['月票数'] = df1['月票数'].str.replace('月票','').astype(np.int32)
df1['排名'] = df1['排名'].str.replace('NO.','')
print(df1)

df2 = pd.read_csv('./畅销.csv')

df2['排名'] = df2['排名'].str.replace('NO.','')
#print(df2)

df3 = pd.read_csv('收藏.csv')
df3['排名'] = df3['排名'].str.replace('NO.','')
df3['收藏数'] = df3['收藏数'].str.replace('收藏数','').astype(np.int32)
#print(df3)

data = [df,df1,df2,df3]
df = pd.concat(data,axis=1)
df_1 = df.to_csv('./总览.csv')
print(df)